CREATE TABLE [dbo].[Product]
(
[ProductId] [int] NOT NULL IDENTITY(1, 1),
[ProductCategoryId] [int] NULL,
[Name] [nvarchar] (128) COLLATE Cyrillic_General_CI_AS NULL,
[Price] [money] NULL,
[Quantity] [int] NULL,
[Description] [nvarchar] (4000) COLLATE Cyrillic_General_CI_AS NULL,
[CreatedDate] [datetime] NULL,
[LastModifiedDate] [datetime] NULL,
[IsDeleted] [bit] NULL,
[IsVisible] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Product] ADD CONSTRAINT [PK_Product] PRIMARY KEY CLUSTERED  ([ProductId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Product] ADD CONSTRAINT [FK_Product_ProductCategory] FOREIGN KEY ([ProductCategoryId]) REFERENCES [dbo].[ProductCategory] ([ProductCategoryId])
GO
